create view Company_Index ( ID, ORG_CODE, MEMBER_TYPE, CATEGORY, STATUS, COMPANY_SORT, FULL_ADDRESS, COMPANY, CITY, STATE_PROVINCE, COUNTRY ) AS select ID, ORG_CODE, MEMBER_TYPE, CATEGORY, STATUS, COMPANY_SORT, FULL_ADDRESS, COMPANY, CITY, STATE_PROVINCE, COUNTRY from Name where Name.COMPANY_RECORD = 1

GO
GRANT REFERENCES ON  [dbo].[Company_Index] TO [IMIS]
GRANT SELECT ON  [dbo].[Company_Index] TO [IMIS]
GRANT INSERT ON  [dbo].[Company_Index] TO [IMIS]
GRANT DELETE ON  [dbo].[Company_Index] TO [IMIS]
GRANT UPDATE ON  [dbo].[Company_Index] TO [IMIS]
GO